Tabela LOncologicCardStageStatus

Definicja tabeli LOncologicCardStageStatus

Name

LOncologicCardStageStatus

Code

LOncologicCardStageStatus

Comment

tabela przechowuje historie zmian statusów etapów karty onkologicznej dla tabeli OncologicCard


Lista kolumn tabeli LOncologicCardStageStatus

Name

Code

LOncologicCardStageStatusID

LOncologicCardStageStatusID

OncologicCardID

OncologicCardID

StageOfProceedingID

StageOfProceedingID

OncologicCardStageStatusID

OncologicCardStageStatusID

Reason

Reason


Kolumna LOncologicCardStageStatusID tabeli LOncologicCardStageStatus

Definicja kolumny LOncologicCardStageStatusID tabeli LOncologicCardStageStatus

Name

LOncologicCardStageStatusID

Code

LOncologicCardStageStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna OncologicCardID tabeli LOncologicCardStageStatus

Definicja kolumny OncologicCardID tabeli LOncologicCardStageStatus

Name

OncologicCardID

Code

OncologicCardID

Data Type

NUMBER(10)

Mandatory

No

Comment

link do tabeli OncologicCard.OncologicCardID


Kolumna StageOfProceedingID tabeli LOncologicCardStageStatus

Definicja kolumny StageOfProceedingID tabeli LOncologicCardStageStatus

Name

StageOfProceedingID

Code

StageOfProceedingID

Data Type

NUMBER(10)

Mandatory

No

Comment

etap karty onkologicznej (slownik DictionaryID = -941)


Kolumna OncologicCardStageStatusID tabeli LOncologicCardStageStatus

Definicja kolumny OncologicCardStageStatusID tabeli LOncologicCardStageStatus

Name

OncologicCardStageStatusID

Code

OncologicCardStageStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

status karty onkologicznej (link do OncologicCardStageStatus.OncologicCardStageStatusID)


Kolumna Reason tabeli LOncologicCardStageStatus

Definicja kolumny Reason tabeli LOncologicCardStageStatus

Name

Reason

Code

Reason

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Kolumna bedzie przechowywac powód zmiany statusu karty onkologicznej


Lista kluczy tabeli LOncologicCardStageStatus

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LOncologicCardStageStatus

Definicja klucza Identifier_1 tabeli LOncologicCardStageStatus

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment